package com.deyuanyun.pic.pipe.domain;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SteelPipeExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SteelPipeExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID_ is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID_ is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID_ =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID_ <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID_ >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID_ >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID_ <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID_ <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID_ like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID_ not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID_ in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID_ not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID_ between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID_ not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("CREATE_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("CREATE_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("CREATE_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("CREATE_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("CREATE_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("CREATE_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("CREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("CREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("CREATE_USER =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("CREATE_USER <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("CREATE_USER >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("CREATE_USER <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("CREATE_USER like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("CREATE_USER not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("CREATE_USER in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("CREATE_USER not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("CREATE_USER between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNull() {
            addCriterion("CREATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNotNull() {
            addCriterion("CREATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkEqualTo(String value) {
            addCriterion("CREATE_REMARK =", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotEqualTo(String value) {
            addCriterion("CREATE_REMARK <>", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThan(String value) {
            addCriterion("CREATE_REMARK >", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK >=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThan(String value) {
            addCriterion("CREATE_REMARK <", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK <=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLike(String value) {
            addCriterion("CREATE_REMARK like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotLike(String value) {
            addCriterion("CREATE_REMARK not like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIn(List<String> values) {
            addCriterion("CREATE_REMARK in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotIn(List<String> values) {
            addCriterion("CREATE_REMARK not in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK not between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("UPDATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("UPDATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("UPDATE_DATE =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("UPDATE_DATE <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("UPDATE_DATE >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("UPDATE_DATE <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("UPDATE_DATE in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("UPDATE_DATE not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("UPDATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("UPDATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("UPDATE_USER =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("UPDATE_USER <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("UPDATE_USER >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("UPDATE_USER <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("UPDATE_USER like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("UPDATE_USER not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("UPDATE_USER in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("UPDATE_USER not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("UPDATE_USER between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("UPDATE_USER not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNull() {
            addCriterion("UPDATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNotNull() {
            addCriterion("UPDATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkEqualTo(String value) {
            addCriterion("UPDATE_REMARK =", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotEqualTo(String value) {
            addCriterion("UPDATE_REMARK <>", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThan(String value) {
            addCriterion("UPDATE_REMARK >", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK >=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThan(String value) {
            addCriterion("UPDATE_REMARK <", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK <=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLike(String value) {
            addCriterion("UPDATE_REMARK like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotLike(String value) {
            addCriterion("UPDATE_REMARK not like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIn(List<String> values) {
            addCriterion("UPDATE_REMARK in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotIn(List<String> values) {
            addCriterion("UPDATE_REMARK not in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK not between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("DELETED is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("DELETED is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Short value) {
            addCriterion("DELETED =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Short value) {
            addCriterion("DELETED <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Short value) {
            addCriterion("DELETED >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Short value) {
            addCriterion("DELETED >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Short value) {
            addCriterion("DELETED <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Short value) {
            addCriterion("DELETED <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Short> values) {
            addCriterion("DELETED in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Short> values) {
            addCriterion("DELETED not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Short value1, Short value2) {
            addCriterion("DELETED between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Short value1, Short value2) {
            addCriterion("DELETED not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andVsersionIsNull() {
            addCriterion("VSERSION is null");
            return (Criteria) this;
        }

        public Criteria andVsersionIsNotNull() {
            addCriterion("VSERSION is not null");
            return (Criteria) this;
        }

        public Criteria andVsersionEqualTo(Short value) {
            addCriterion("VSERSION =", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotEqualTo(Short value) {
            addCriterion("VSERSION <>", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionGreaterThan(Short value) {
            addCriterion("VSERSION >", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionGreaterThanOrEqualTo(Short value) {
            addCriterion("VSERSION >=", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionLessThan(Short value) {
            addCriterion("VSERSION <", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionLessThanOrEqualTo(Short value) {
            addCriterion("VSERSION <=", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionIn(List<Short> values) {
            addCriterion("VSERSION in", values, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotIn(List<Short> values) {
            addCriterion("VSERSION not in", values, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionBetween(Short value1, Short value2) {
            addCriterion("VSERSION between", value1, value2, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotBetween(Short value1, Short value2) {
            addCriterion("VSERSION not between", value1, value2, "vsersion");
            return (Criteria) this;
        }

        public Criteria andIsNewestIsNull() {
            addCriterion("IS_NEWEST is null");
            return (Criteria) this;
        }

        public Criteria andIsNewestIsNotNull() {
            addCriterion("IS_NEWEST is not null");
            return (Criteria) this;
        }

        public Criteria andIsNewestEqualTo(Short value) {
            addCriterion("IS_NEWEST =", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotEqualTo(Short value) {
            addCriterion("IS_NEWEST <>", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestGreaterThan(Short value) {
            addCriterion("IS_NEWEST >", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestGreaterThanOrEqualTo(Short value) {
            addCriterion("IS_NEWEST >=", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestLessThan(Short value) {
            addCriterion("IS_NEWEST <", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestLessThanOrEqualTo(Short value) {
            addCriterion("IS_NEWEST <=", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestIn(List<Short> values) {
            addCriterion("IS_NEWEST in", values, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotIn(List<Short> values) {
            addCriterion("IS_NEWEST not in", values, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestBetween(Short value1, Short value2) {
            addCriterion("IS_NEWEST between", value1, value2, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotBetween(Short value1, Short value2) {
            addCriterion("IS_NEWEST not between", value1, value2, "isNewest");
            return (Criteria) this;
        }

        public Criteria andDataStatedIsNull() {
            addCriterion("DATA_STATED is null");
            return (Criteria) this;
        }

        public Criteria andDataStatedIsNotNull() {
            addCriterion("DATA_STATED is not null");
            return (Criteria) this;
        }

        public Criteria andDataStatedEqualTo(String value) {
            addCriterion("DATA_STATED =", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotEqualTo(String value) {
            addCriterion("DATA_STATED <>", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedGreaterThan(String value) {
            addCriterion("DATA_STATED >", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedGreaterThanOrEqualTo(String value) {
            addCriterion("DATA_STATED >=", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLessThan(String value) {
            addCriterion("DATA_STATED <", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLessThanOrEqualTo(String value) {
            addCriterion("DATA_STATED <=", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLike(String value) {
            addCriterion("DATA_STATED like", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotLike(String value) {
            addCriterion("DATA_STATED not like", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedIn(List<String> values) {
            addCriterion("DATA_STATED in", values, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotIn(List<String> values) {
            addCriterion("DATA_STATED not in", values, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedBetween(String value1, String value2) {
            addCriterion("DATA_STATED between", value1, value2, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotBetween(String value1, String value2) {
            addCriterion("DATA_STATED not between", value1, value2, "dataStated");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIsNull() {
            addCriterion("PIPE_LINE_ID is null");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIsNotNull() {
            addCriterion("PIPE_LINE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdEqualTo(String value) {
            addCriterion("PIPE_LINE_ID =", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotEqualTo(String value) {
            addCriterion("PIPE_LINE_ID <>", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdGreaterThan(String value) {
            addCriterion("PIPE_LINE_ID >", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_LINE_ID >=", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLessThan(String value) {
            addCriterion("PIPE_LINE_ID <", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLessThanOrEqualTo(String value) {
            addCriterion("PIPE_LINE_ID <=", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLike(String value) {
            addCriterion("PIPE_LINE_ID like", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotLike(String value) {
            addCriterion("PIPE_LINE_ID not like", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIn(List<String> values) {
            addCriterion("PIPE_LINE_ID in", values, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotIn(List<String> values) {
            addCriterion("PIPE_LINE_ID not in", values, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdBetween(String value1, String value2) {
            addCriterion("PIPE_LINE_ID between", value1, value2, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotBetween(String value1, String value2) {
            addCriterion("PIPE_LINE_ID not between", value1, value2, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("CODE is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("CODE =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("CODE <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("CODE >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CODE >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("CODE <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("CODE <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("CODE like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("CODE not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("CODE in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("CODE not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("CODE between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("CODE not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andPipeNumberIsNull() {
            addCriterion("PIPE_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andPipeNumberIsNotNull() {
            addCriterion("PIPE_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andPipeNumberEqualTo(String value) {
            addCriterion("PIPE_NUMBER =", value, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andPipeNumberNotEqualTo(String value) {
            addCriterion("PIPE_NUMBER <>", value, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andPipeNumberGreaterThan(String value) {
            addCriterion("PIPE_NUMBER >", value, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andPipeNumberGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_NUMBER >=", value, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andPipeNumberLessThan(String value) {
            addCriterion("PIPE_NUMBER <", value, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andPipeNumberLessThanOrEqualTo(String value) {
            addCriterion("PIPE_NUMBER <=", value, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andPipeNumberLike(String value) {
            addCriterion("PIPE_NUMBER like", value, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andPipeNumberNotLike(String value) {
            addCriterion("PIPE_NUMBER not like", value, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andPipeNumberIn(List<String> values) {
            addCriterion("PIPE_NUMBER in", values, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andPipeNumberNotIn(List<String> values) {
            addCriterion("PIPE_NUMBER not in", values, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andPipeNumberBetween(String value1, String value2) {
            addCriterion("PIPE_NUMBER between", value1, value2, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andPipeNumberNotBetween(String value1, String value2) {
            addCriterion("PIPE_NUMBER not between", value1, value2, "pipeNumber");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumIsNull() {
            addCriterion("MANUFACTURED_NUM is null");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumIsNotNull() {
            addCriterion("MANUFACTURED_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumEqualTo(String value) {
            addCriterion("MANUFACTURED_NUM =", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumNotEqualTo(String value) {
            addCriterion("MANUFACTURED_NUM <>", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumGreaterThan(String value) {
            addCriterion("MANUFACTURED_NUM >", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumGreaterThanOrEqualTo(String value) {
            addCriterion("MANUFACTURED_NUM >=", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumLessThan(String value) {
            addCriterion("MANUFACTURED_NUM <", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumLessThanOrEqualTo(String value) {
            addCriterion("MANUFACTURED_NUM <=", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumLike(String value) {
            addCriterion("MANUFACTURED_NUM like", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumNotLike(String value) {
            addCriterion("MANUFACTURED_NUM not like", value, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumIn(List<String> values) {
            addCriterion("MANUFACTURED_NUM in", values, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumNotIn(List<String> values) {
            addCriterion("MANUFACTURED_NUM not in", values, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumBetween(String value1, String value2) {
            addCriterion("MANUFACTURED_NUM between", value1, value2, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andManufacturedNumNotBetween(String value1, String value2) {
            addCriterion("MANUFACTURED_NUM not between", value1, value2, "manufacturedNum");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNull() {
            addCriterion("MATERIAL is null");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNotNull() {
            addCriterion("MATERIAL is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialEqualTo(String value) {
            addCriterion("MATERIAL =", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotEqualTo(String value) {
            addCriterion("MATERIAL <>", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThan(String value) {
            addCriterion("MATERIAL >", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL >=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThan(String value) {
            addCriterion("MATERIAL <", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL <=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLike(String value) {
            addCriterion("MATERIAL like", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotLike(String value) {
            addCriterion("MATERIAL not like", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialIn(List<String> values) {
            addCriterion("MATERIAL in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotIn(List<String> values) {
            addCriterion("MATERIAL not in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialBetween(String value1, String value2) {
            addCriterion("MATERIAL between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotBetween(String value1, String value2) {
            addCriterion("MATERIAL not between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andPipeTypeIsNull() {
            addCriterion("PIPE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andPipeTypeIsNotNull() {
            addCriterion("PIPE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andPipeTypeEqualTo(String value) {
            addCriterion("PIPE_TYPE =", value, "pipeType");
            return (Criteria) this;
        }

        public Criteria andPipeTypeNotEqualTo(String value) {
            addCriterion("PIPE_TYPE <>", value, "pipeType");
            return (Criteria) this;
        }

        public Criteria andPipeTypeGreaterThan(String value) {
            addCriterion("PIPE_TYPE >", value, "pipeType");
            return (Criteria) this;
        }

        public Criteria andPipeTypeGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_TYPE >=", value, "pipeType");
            return (Criteria) this;
        }

        public Criteria andPipeTypeLessThan(String value) {
            addCriterion("PIPE_TYPE <", value, "pipeType");
            return (Criteria) this;
        }

        public Criteria andPipeTypeLessThanOrEqualTo(String value) {
            addCriterion("PIPE_TYPE <=", value, "pipeType");
            return (Criteria) this;
        }

        public Criteria andPipeTypeLike(String value) {
            addCriterion("PIPE_TYPE like", value, "pipeType");
            return (Criteria) this;
        }

        public Criteria andPipeTypeNotLike(String value) {
            addCriterion("PIPE_TYPE not like", value, "pipeType");
            return (Criteria) this;
        }

        public Criteria andPipeTypeIn(List<String> values) {
            addCriterion("PIPE_TYPE in", values, "pipeType");
            return (Criteria) this;
        }

        public Criteria andPipeTypeNotIn(List<String> values) {
            addCriterion("PIPE_TYPE not in", values, "pipeType");
            return (Criteria) this;
        }

        public Criteria andPipeTypeBetween(String value1, String value2) {
            addCriterion("PIPE_TYPE between", value1, value2, "pipeType");
            return (Criteria) this;
        }

        public Criteria andPipeTypeNotBetween(String value1, String value2) {
            addCriterion("PIPE_TYPE not between", value1, value2, "pipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeIsNull() {
            addCriterion("MANUPIPESEAM_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeIsNotNull() {
            addCriterion("MANUPIPESEAM_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeEqualTo(String value) {
            addCriterion("MANUPIPESEAM_TYPE =", value, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeNotEqualTo(String value) {
            addCriterion("MANUPIPESEAM_TYPE <>", value, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeGreaterThan(String value) {
            addCriterion("MANUPIPESEAM_TYPE >", value, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeGreaterThanOrEqualTo(String value) {
            addCriterion("MANUPIPESEAM_TYPE >=", value, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeLessThan(String value) {
            addCriterion("MANUPIPESEAM_TYPE <", value, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeLessThanOrEqualTo(String value) {
            addCriterion("MANUPIPESEAM_TYPE <=", value, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeLike(String value) {
            addCriterion("MANUPIPESEAM_TYPE like", value, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeNotLike(String value) {
            addCriterion("MANUPIPESEAM_TYPE not like", value, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeIn(List<String> values) {
            addCriterion("MANUPIPESEAM_TYPE in", values, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeNotIn(List<String> values) {
            addCriterion("MANUPIPESEAM_TYPE not in", values, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeBetween(String value1, String value2) {
            addCriterion("MANUPIPESEAM_TYPE between", value1, value2, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andManupipeseamTypeNotBetween(String value1, String value2) {
            addCriterion("MANUPIPESEAM_TYPE not between", value1, value2, "manupipeseamType");
            return (Criteria) this;
        }

        public Criteria andUgwwIdIsNull() {
            addCriterion("UGWW_ID is null");
            return (Criteria) this;
        }

        public Criteria andUgwwIdIsNotNull() {
            addCriterion("UGWW_ID is not null");
            return (Criteria) this;
        }

        public Criteria andUgwwIdEqualTo(String value) {
            addCriterion("UGWW_ID =", value, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andUgwwIdNotEqualTo(String value) {
            addCriterion("UGWW_ID <>", value, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andUgwwIdGreaterThan(String value) {
            addCriterion("UGWW_ID >", value, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andUgwwIdGreaterThanOrEqualTo(String value) {
            addCriterion("UGWW_ID >=", value, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andUgwwIdLessThan(String value) {
            addCriterion("UGWW_ID <", value, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andUgwwIdLessThanOrEqualTo(String value) {
            addCriterion("UGWW_ID <=", value, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andUgwwIdLike(String value) {
            addCriterion("UGWW_ID like", value, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andUgwwIdNotLike(String value) {
            addCriterion("UGWW_ID not like", value, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andUgwwIdIn(List<String> values) {
            addCriterion("UGWW_ID in", values, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andUgwwIdNotIn(List<String> values) {
            addCriterion("UGWW_ID not in", values, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andUgwwIdBetween(String value1, String value2) {
            addCriterion("UGWW_ID between", value1, value2, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andUgwwIdNotBetween(String value1, String value2) {
            addCriterion("UGWW_ID not between", value1, value2, "ugwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdIsNull() {
            addCriterion("DGWW_ID is null");
            return (Criteria) this;
        }

        public Criteria andDgwwIdIsNotNull() {
            addCriterion("DGWW_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDgwwIdEqualTo(String value) {
            addCriterion("DGWW_ID =", value, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdNotEqualTo(String value) {
            addCriterion("DGWW_ID <>", value, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdGreaterThan(String value) {
            addCriterion("DGWW_ID >", value, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdGreaterThanOrEqualTo(String value) {
            addCriterion("DGWW_ID >=", value, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdLessThan(String value) {
            addCriterion("DGWW_ID <", value, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdLessThanOrEqualTo(String value) {
            addCriterion("DGWW_ID <=", value, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdLike(String value) {
            addCriterion("DGWW_ID like", value, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdNotLike(String value) {
            addCriterion("DGWW_ID not like", value, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdIn(List<String> values) {
            addCriterion("DGWW_ID in", values, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdNotIn(List<String> values) {
            addCriterion("DGWW_ID not in", values, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdBetween(String value1, String value2) {
            addCriterion("DGWW_ID between", value1, value2, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andDgwwIdNotBetween(String value1, String value2) {
            addCriterion("DGWW_ID not between", value1, value2, "dgwwId");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumIsNull() {
            addCriterion("STOVESERIAL_NUM is null");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumIsNotNull() {
            addCriterion("STOVESERIAL_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumEqualTo(String value) {
            addCriterion("STOVESERIAL_NUM =", value, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumNotEqualTo(String value) {
            addCriterion("STOVESERIAL_NUM <>", value, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumGreaterThan(String value) {
            addCriterion("STOVESERIAL_NUM >", value, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumGreaterThanOrEqualTo(String value) {
            addCriterion("STOVESERIAL_NUM >=", value, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumLessThan(String value) {
            addCriterion("STOVESERIAL_NUM <", value, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumLessThanOrEqualTo(String value) {
            addCriterion("STOVESERIAL_NUM <=", value, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumLike(String value) {
            addCriterion("STOVESERIAL_NUM like", value, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumNotLike(String value) {
            addCriterion("STOVESERIAL_NUM not like", value, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumIn(List<String> values) {
            addCriterion("STOVESERIAL_NUM in", values, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumNotIn(List<String> values) {
            addCriterion("STOVESERIAL_NUM not in", values, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumBetween(String value1, String value2) {
            addCriterion("STOVESERIAL_NUM between", value1, value2, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andStoveserialNumNotBetween(String value1, String value2) {
            addCriterion("STOVESERIAL_NUM not between", value1, value2, "stoveserialNum");
            return (Criteria) this;
        }

        public Criteria andDiameterIsNull() {
            addCriterion("DIAMETER is null");
            return (Criteria) this;
        }

        public Criteria andDiameterIsNotNull() {
            addCriterion("DIAMETER is not null");
            return (Criteria) this;
        }

        public Criteria andDiameterEqualTo(String value) {
            addCriterion("DIAMETER =", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotEqualTo(String value) {
            addCriterion("DIAMETER <>", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterGreaterThan(String value) {
            addCriterion("DIAMETER >", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterGreaterThanOrEqualTo(String value) {
            addCriterion("DIAMETER >=", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterLessThan(String value) {
            addCriterion("DIAMETER <", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterLessThanOrEqualTo(String value) {
            addCriterion("DIAMETER <=", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterLike(String value) {
            addCriterion("DIAMETER like", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotLike(String value) {
            addCriterion("DIAMETER not like", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterIn(List<String> values) {
            addCriterion("DIAMETER in", values, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotIn(List<String> values) {
            addCriterion("DIAMETER not in", values, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterBetween(String value1, String value2) {
            addCriterion("DIAMETER between", value1, value2, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotBetween(String value1, String value2) {
            addCriterion("DIAMETER not between", value1, value2, "diameter");
            return (Criteria) this;
        }

        public Criteria andWallThicknessIsNull() {
            addCriterion("WALL_THICKNESS is null");
            return (Criteria) this;
        }

        public Criteria andWallThicknessIsNotNull() {
            addCriterion("WALL_THICKNESS is not null");
            return (Criteria) this;
        }

        public Criteria andWallThicknessEqualTo(BigDecimal value) {
            addCriterion("WALL_THICKNESS =", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessNotEqualTo(BigDecimal value) {
            addCriterion("WALL_THICKNESS <>", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessGreaterThan(BigDecimal value) {
            addCriterion("WALL_THICKNESS >", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WALL_THICKNESS >=", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessLessThan(BigDecimal value) {
            addCriterion("WALL_THICKNESS <", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WALL_THICKNESS <=", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessIn(List<BigDecimal> values) {
            addCriterion("WALL_THICKNESS in", values, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessNotIn(List<BigDecimal> values) {
            addCriterion("WALL_THICKNESS not in", values, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WALL_THICKNESS between", value1, value2, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WALL_THICKNESS not between", value1, value2, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andPipeLengthIsNull() {
            addCriterion("PIPE_LENGTH is null");
            return (Criteria) this;
        }

        public Criteria andPipeLengthIsNotNull() {
            addCriterion("PIPE_LENGTH is not null");
            return (Criteria) this;
        }

        public Criteria andPipeLengthEqualTo(BigDecimal value) {
            addCriterion("PIPE_LENGTH =", value, "pipeLength");
            return (Criteria) this;
        }

        public Criteria andPipeLengthNotEqualTo(BigDecimal value) {
            addCriterion("PIPE_LENGTH <>", value, "pipeLength");
            return (Criteria) this;
        }

        public Criteria andPipeLengthGreaterThan(BigDecimal value) {
            addCriterion("PIPE_LENGTH >", value, "pipeLength");
            return (Criteria) this;
        }

        public Criteria andPipeLengthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PIPE_LENGTH >=", value, "pipeLength");
            return (Criteria) this;
        }

        public Criteria andPipeLengthLessThan(BigDecimal value) {
            addCriterion("PIPE_LENGTH <", value, "pipeLength");
            return (Criteria) this;
        }

        public Criteria andPipeLengthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PIPE_LENGTH <=", value, "pipeLength");
            return (Criteria) this;
        }

        public Criteria andPipeLengthIn(List<BigDecimal> values) {
            addCriterion("PIPE_LENGTH in", values, "pipeLength");
            return (Criteria) this;
        }

        public Criteria andPipeLengthNotIn(List<BigDecimal> values) {
            addCriterion("PIPE_LENGTH not in", values, "pipeLength");
            return (Criteria) this;
        }

        public Criteria andPipeLengthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PIPE_LENGTH between", value1, value2, "pipeLength");
            return (Criteria) this;
        }

        public Criteria andPipeLengthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PIPE_LENGTH not between", value1, value2, "pipeLength");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialIsNull() {
            addCriterion("COATING_MATERIAL is null");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialIsNotNull() {
            addCriterion("COATING_MATERIAL is not null");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialEqualTo(String value) {
            addCriterion("COATING_MATERIAL =", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotEqualTo(String value) {
            addCriterion("COATING_MATERIAL <>", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialGreaterThan(String value) {
            addCriterion("COATING_MATERIAL >", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialGreaterThanOrEqualTo(String value) {
            addCriterion("COATING_MATERIAL >=", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialLessThan(String value) {
            addCriterion("COATING_MATERIAL <", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialLessThanOrEqualTo(String value) {
            addCriterion("COATING_MATERIAL <=", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialLike(String value) {
            addCriterion("COATING_MATERIAL like", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotLike(String value) {
            addCriterion("COATING_MATERIAL not like", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialIn(List<String> values) {
            addCriterion("COATING_MATERIAL in", values, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotIn(List<String> values) {
            addCriterion("COATING_MATERIAL not in", values, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialBetween(String value1, String value2) {
            addCriterion("COATING_MATERIAL between", value1, value2, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotBetween(String value1, String value2) {
            addCriterion("COATING_MATERIAL not between", value1, value2, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceIsNull() {
            addCriterion("COATING_SOURCE is null");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceIsNotNull() {
            addCriterion("COATING_SOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceEqualTo(String value) {
            addCriterion("COATING_SOURCE =", value, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceNotEqualTo(String value) {
            addCriterion("COATING_SOURCE <>", value, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceGreaterThan(String value) {
            addCriterion("COATING_SOURCE >", value, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceGreaterThanOrEqualTo(String value) {
            addCriterion("COATING_SOURCE >=", value, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceLessThan(String value) {
            addCriterion("COATING_SOURCE <", value, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceLessThanOrEqualTo(String value) {
            addCriterion("COATING_SOURCE <=", value, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceLike(String value) {
            addCriterion("COATING_SOURCE like", value, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceNotLike(String value) {
            addCriterion("COATING_SOURCE not like", value, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceIn(List<String> values) {
            addCriterion("COATING_SOURCE in", values, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceNotIn(List<String> values) {
            addCriterion("COATING_SOURCE not in", values, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceBetween(String value1, String value2) {
            addCriterion("COATING_SOURCE between", value1, value2, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andCoatingSourceNotBetween(String value1, String value2) {
            addCriterion("COATING_SOURCE not between", value1, value2, "coatingSource");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalIsNull() {
            addCriterion("INTER_NALOREXTERNAL is null");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalIsNotNull() {
            addCriterion("INTER_NALOREXTERNAL is not null");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalEqualTo(String value) {
            addCriterion("INTER_NALOREXTERNAL =", value, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalNotEqualTo(String value) {
            addCriterion("INTER_NALOREXTERNAL <>", value, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalGreaterThan(String value) {
            addCriterion("INTER_NALOREXTERNAL >", value, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalGreaterThanOrEqualTo(String value) {
            addCriterion("INTER_NALOREXTERNAL >=", value, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalLessThan(String value) {
            addCriterion("INTER_NALOREXTERNAL <", value, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalLessThanOrEqualTo(String value) {
            addCriterion("INTER_NALOREXTERNAL <=", value, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalLike(String value) {
            addCriterion("INTER_NALOREXTERNAL like", value, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalNotLike(String value) {
            addCriterion("INTER_NALOREXTERNAL not like", value, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalIn(List<String> values) {
            addCriterion("INTER_NALOREXTERNAL in", values, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalNotIn(List<String> values) {
            addCriterion("INTER_NALOREXTERNAL not in", values, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalBetween(String value1, String value2) {
            addCriterion("INTER_NALOREXTERNAL between", value1, value2, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andInterNalorexternalNotBetween(String value1, String value2) {
            addCriterion("INTER_NALOREXTERNAL not between", value1, value2, "interNalorexternal");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessIsNull() {
            addCriterion("COATING_THICKNESS is null");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessIsNotNull() {
            addCriterion("COATING_THICKNESS is not null");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessEqualTo(BigDecimal value) {
            addCriterion("COATING_THICKNESS =", value, "coatingThickness");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessNotEqualTo(BigDecimal value) {
            addCriterion("COATING_THICKNESS <>", value, "coatingThickness");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessGreaterThan(BigDecimal value) {
            addCriterion("COATING_THICKNESS >", value, "coatingThickness");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("COATING_THICKNESS >=", value, "coatingThickness");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessLessThan(BigDecimal value) {
            addCriterion("COATING_THICKNESS <", value, "coatingThickness");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessLessThanOrEqualTo(BigDecimal value) {
            addCriterion("COATING_THICKNESS <=", value, "coatingThickness");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessIn(List<BigDecimal> values) {
            addCriterion("COATING_THICKNESS in", values, "coatingThickness");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessNotIn(List<BigDecimal> values) {
            addCriterion("COATING_THICKNESS not in", values, "coatingThickness");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("COATING_THICKNESS between", value1, value2, "coatingThickness");
            return (Criteria) this;
        }

        public Criteria andCoatingThicknessNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("COATING_THICKNESS not between", value1, value2, "coatingThickness");
            return (Criteria) this;
        }

        public Criteria andTestVoltageIsNull() {
            addCriterion("TEST_VOLTAGE is null");
            return (Criteria) this;
        }

        public Criteria andTestVoltageIsNotNull() {
            addCriterion("TEST_VOLTAGE is not null");
            return (Criteria) this;
        }

        public Criteria andTestVoltageEqualTo(BigDecimal value) {
            addCriterion("TEST_VOLTAGE =", value, "testVoltage");
            return (Criteria) this;
        }

        public Criteria andTestVoltageNotEqualTo(BigDecimal value) {
            addCriterion("TEST_VOLTAGE <>", value, "testVoltage");
            return (Criteria) this;
        }

        public Criteria andTestVoltageGreaterThan(BigDecimal value) {
            addCriterion("TEST_VOLTAGE >", value, "testVoltage");
            return (Criteria) this;
        }

        public Criteria andTestVoltageGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TEST_VOLTAGE >=", value, "testVoltage");
            return (Criteria) this;
        }

        public Criteria andTestVoltageLessThan(BigDecimal value) {
            addCriterion("TEST_VOLTAGE <", value, "testVoltage");
            return (Criteria) this;
        }

        public Criteria andTestVoltageLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TEST_VOLTAGE <=", value, "testVoltage");
            return (Criteria) this;
        }

        public Criteria andTestVoltageIn(List<BigDecimal> values) {
            addCriterion("TEST_VOLTAGE in", values, "testVoltage");
            return (Criteria) this;
        }

        public Criteria andTestVoltageNotIn(List<BigDecimal> values) {
            addCriterion("TEST_VOLTAGE not in", values, "testVoltage");
            return (Criteria) this;
        }

        public Criteria andTestVoltageBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TEST_VOLTAGE between", value1, value2, "testVoltage");
            return (Criteria) this;
        }

        public Criteria andTestVoltageNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TEST_VOLTAGE not between", value1, value2, "testVoltage");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerIsNull() {
            addCriterion("PIPE_MANUFACTURER is null");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerIsNotNull() {
            addCriterion("PIPE_MANUFACTURER is not null");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerEqualTo(String value) {
            addCriterion("PIPE_MANUFACTURER =", value, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerNotEqualTo(String value) {
            addCriterion("PIPE_MANUFACTURER <>", value, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerGreaterThan(String value) {
            addCriterion("PIPE_MANUFACTURER >", value, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_MANUFACTURER >=", value, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerLessThan(String value) {
            addCriterion("PIPE_MANUFACTURER <", value, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerLessThanOrEqualTo(String value) {
            addCriterion("PIPE_MANUFACTURER <=", value, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerLike(String value) {
            addCriterion("PIPE_MANUFACTURER like", value, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerNotLike(String value) {
            addCriterion("PIPE_MANUFACTURER not like", value, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerIn(List<String> values) {
            addCriterion("PIPE_MANUFACTURER in", values, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerNotIn(List<String> values) {
            addCriterion("PIPE_MANUFACTURER not in", values, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerBetween(String value1, String value2) {
            addCriterion("PIPE_MANUFACTURER between", value1, value2, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufacturerNotBetween(String value1, String value2) {
            addCriterion("PIPE_MANUFACTURER not between", value1, value2, "pipeManufacturer");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateIsNull() {
            addCriterion("PIPE_MANUFACTURE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateIsNotNull() {
            addCriterion("PIPE_MANUFACTURE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateEqualTo(Date value) {
            addCriterion("PIPE_MANUFACTURE_DATE =", value, "pipeManufactureDate");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateNotEqualTo(Date value) {
            addCriterion("PIPE_MANUFACTURE_DATE <>", value, "pipeManufactureDate");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateGreaterThan(Date value) {
            addCriterion("PIPE_MANUFACTURE_DATE >", value, "pipeManufactureDate");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateGreaterThanOrEqualTo(Date value) {
            addCriterion("PIPE_MANUFACTURE_DATE >=", value, "pipeManufactureDate");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateLessThan(Date value) {
            addCriterion("PIPE_MANUFACTURE_DATE <", value, "pipeManufactureDate");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateLessThanOrEqualTo(Date value) {
            addCriterion("PIPE_MANUFACTURE_DATE <=", value, "pipeManufactureDate");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateIn(List<Date> values) {
            addCriterion("PIPE_MANUFACTURE_DATE in", values, "pipeManufactureDate");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateNotIn(List<Date> values) {
            addCriterion("PIPE_MANUFACTURE_DATE not in", values, "pipeManufactureDate");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateBetween(Date value1, Date value2) {
            addCriterion("PIPE_MANUFACTURE_DATE between", value1, value2, "pipeManufactureDate");
            return (Criteria) this;
        }

        public Criteria andPipeManufactureDateNotBetween(Date value1, Date value2) {
            addCriterion("PIPE_MANUFACTURE_DATE not between", value1, value2, "pipeManufactureDate");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerIsNull() {
            addCriterion("COATING_MANUFACTURER is null");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerIsNotNull() {
            addCriterion("COATING_MANUFACTURER is not null");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerEqualTo(String value) {
            addCriterion("COATING_MANUFACTURER =", value, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerNotEqualTo(String value) {
            addCriterion("COATING_MANUFACTURER <>", value, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerGreaterThan(String value) {
            addCriterion("COATING_MANUFACTURER >", value, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerGreaterThanOrEqualTo(String value) {
            addCriterion("COATING_MANUFACTURER >=", value, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerLessThan(String value) {
            addCriterion("COATING_MANUFACTURER <", value, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerLessThanOrEqualTo(String value) {
            addCriterion("COATING_MANUFACTURER <=", value, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerLike(String value) {
            addCriterion("COATING_MANUFACTURER like", value, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerNotLike(String value) {
            addCriterion("COATING_MANUFACTURER not like", value, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerIn(List<String> values) {
            addCriterion("COATING_MANUFACTURER in", values, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerNotIn(List<String> values) {
            addCriterion("COATING_MANUFACTURER not in", values, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerBetween(String value1, String value2) {
            addCriterion("COATING_MANUFACTURER between", value1, value2, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufacturerNotBetween(String value1, String value2) {
            addCriterion("COATING_MANUFACTURER not between", value1, value2, "coatingManufacturer");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateIsNull() {
            addCriterion("COATING_MANUFACTURE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateIsNotNull() {
            addCriterion("COATING_MANUFACTURE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateEqualTo(Date value) {
            addCriterion("COATING_MANUFACTURE_DATE =", value, "coatingManufactureDate");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateNotEqualTo(Date value) {
            addCriterion("COATING_MANUFACTURE_DATE <>", value, "coatingManufactureDate");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateGreaterThan(Date value) {
            addCriterion("COATING_MANUFACTURE_DATE >", value, "coatingManufactureDate");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateGreaterThanOrEqualTo(Date value) {
            addCriterion("COATING_MANUFACTURE_DATE >=", value, "coatingManufactureDate");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateLessThan(Date value) {
            addCriterion("COATING_MANUFACTURE_DATE <", value, "coatingManufactureDate");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateLessThanOrEqualTo(Date value) {
            addCriterion("COATING_MANUFACTURE_DATE <=", value, "coatingManufactureDate");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateIn(List<Date> values) {
            addCriterion("COATING_MANUFACTURE_DATE in", values, "coatingManufactureDate");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateNotIn(List<Date> values) {
            addCriterion("COATING_MANUFACTURE_DATE not in", values, "coatingManufactureDate");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateBetween(Date value1, Date value2) {
            addCriterion("COATING_MANUFACTURE_DATE between", value1, value2, "coatingManufactureDate");
            return (Criteria) this;
        }

        public Criteria andCoatingManufactureDateNotBetween(Date value1, Date value2) {
            addCriterion("COATING_MANUFACTURE_DATE not between", value1, value2, "coatingManufactureDate");
            return (Criteria) this;
        }

        public Criteria andRecorderIsNull() {
            addCriterion("RECORDER is null");
            return (Criteria) this;
        }

        public Criteria andRecorderIsNotNull() {
            addCriterion("RECORDER is not null");
            return (Criteria) this;
        }

        public Criteria andRecorderEqualTo(String value) {
            addCriterion("RECORDER =", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotEqualTo(String value) {
            addCriterion("RECORDER <>", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderGreaterThan(String value) {
            addCriterion("RECORDER >", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderGreaterThanOrEqualTo(String value) {
            addCriterion("RECORDER >=", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLessThan(String value) {
            addCriterion("RECORDER <", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLessThanOrEqualTo(String value) {
            addCriterion("RECORDER <=", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLike(String value) {
            addCriterion("RECORDER like", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotLike(String value) {
            addCriterion("RECORDER not like", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderIn(List<String> values) {
            addCriterion("RECORDER in", values, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotIn(List<String> values) {
            addCriterion("RECORDER not in", values, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderBetween(String value1, String value2) {
            addCriterion("RECORDER between", value1, value2, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotBetween(String value1, String value2) {
            addCriterion("RECORDER not between", value1, value2, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecordtimeIsNull() {
            addCriterion("RECORDTIME is null");
            return (Criteria) this;
        }

        public Criteria andRecordtimeIsNotNull() {
            addCriterion("RECORDTIME is not null");
            return (Criteria) this;
        }

        public Criteria andRecordtimeEqualTo(Date value) {
            addCriterion("RECORDTIME =", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeNotEqualTo(Date value) {
            addCriterion("RECORDTIME <>", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeGreaterThan(Date value) {
            addCriterion("RECORDTIME >", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("RECORDTIME >=", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeLessThan(Date value) {
            addCriterion("RECORDTIME <", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeLessThanOrEqualTo(Date value) {
            addCriterion("RECORDTIME <=", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeIn(List<Date> values) {
            addCriterion("RECORDTIME in", values, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeNotIn(List<Date> values) {
            addCriterion("RECORDTIME not in", values, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeBetween(Date value1, Date value2) {
            addCriterion("RECORDTIME between", value1, value2, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeNotBetween(Date value1, Date value2) {
            addCriterion("RECORDTIME not between", value1, value2, "recordtime");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIsNull() {
            addCriterion("ORG_BIZ_PATH is null");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIsNotNull() {
            addCriterion("ORG_BIZ_PATH is not null");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH =", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH <>", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathGreaterThan(String value) {
            addCriterion("ORG_BIZ_PATH >", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH >=", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLessThan(String value) {
            addCriterion("ORG_BIZ_PATH <", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLessThanOrEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH <=", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLike(String value) {
            addCriterion("ORG_BIZ_PATH like", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotLike(String value) {
            addCriterion("ORG_BIZ_PATH not like", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIn(List<String> values) {
            addCriterion("ORG_BIZ_PATH in", values, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotIn(List<String> values) {
            addCriterion("ORG_BIZ_PATH not in", values, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathBetween(String value1, String value2) {
            addCriterion("ORG_BIZ_PATH between", value1, value2, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotBetween(String value1, String value2) {
            addCriterion("ORG_BIZ_PATH not between", value1, value2, "orgBizPath");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}